ETL and its impact on Business Intelligence
نویسنده
چکیده
Business Intelligence (BI) is considered to have a high impact on businesses. Research activity has risen in the last years. An important part of BI systems is a well performing implementation of the Extract, Transform, and Load (ETL) process. In typical BI projects, implementing the ETL process can be the task with the greatest effort.
منابع مشابه
Application of ETL Tools in Business Intelligence
Business intelligence (BI) is considered to have a high impact on businesses. Research activity has risen in the last years. An important part of BI systems is a well performing implementation of the Extract, Transform, and Load (ETL) process. In typical BI projects, implementing the ETL process can be the task with the greatest effort. Here, set of generic metamodel constructs with a palette o...
متن کاملImproving the Data Warehouse Architecture Using Design Patterns
Data warehousing is an important part of the enterprise information system. Business intelligence (BI) relies on data warehouses to improve business performance. Data quality plays a key role in BI. Source data is extracted, transformed, and loaded (ETL) into the data warehouses periodically. The ETL operations have the most crucial impact on the data quality of the data warehouse. ETL-related ...
متن کاملThe Impact of Business Intelligence on Marketing Performance with Moderating Role of Environmental Turbulence
In today's complex, dynamic and constantly changing environment, companies need to design and take systems and methods that can help them adapt themselves to the changeable and dynamic situation of competitive markets, and therefore improving marketing performance and generally the company’s performance. In this regard, business intelligence systems as a new method and tool can be considered as...
متن کاملLeveraging Business Process Models for ETL Design
As Business Intelligence evolves from off-line strategic decision making to on-line operational decision making, the design of the back-end Extract-Transform-Load (ETL) processes is becoming even more complex. Many challenges arise in this new context like their optimization and modeling. In this paper, we focus on the disconnection between the IT-level view of the enterprise presented by ETL p...
متن کاملBPMN-Based Conceptual Modeling of ETL Processes
Business Intelligence (BI) solutions require the design and implementation of complex processes (denoted ETL) that extract, transform, and load data from the sources to a common repository. New applications, like for example, real-time data warehousing, require agile and flexible tools that allow BI users to take timely decisions based on extremely up-to-date data. This calls for new ETL tools ...
متن کامل